home *** CD-ROM | disk | FTP | other *** search
/ Shareware Overload Trio 2 / Shareware Overload Trio Volume 2 (Chestnut CD-ROM).ISO / dir43 / qsrc_dsk.zip / QUERIES / CHAP6004.QPR < prev    next >
Text File  |  1991-12-17  |  1KB  |  25 lines
  1. *       ╓─────────────────────────────────────────────────────────╖
  2. *       ║                                                         ║
  3. *       ║ CHAP6004.QPR                                            ║
  4. *       ║                                                         ║
  5. *       ╟─────────────────────────────────────────────────────────╢
  6. *       ║ Application Developed in _Using FoxPro 2_               ║
  7. *       ║                                                         ║
  8. *       ║ Lisa C. Slater and Steven E. Arnott                     ║
  9. *       ║                                                         ║
  10. *       ║ Copyright (c) 1991 Que Publishing                       ║
  11. *       ║                                                         ║
  12. *       ╙─────────────────────────────────────────────────────────╜
  13.  
  14.  
  15. SELECT CUSTOMER.COMPANY, PARTS.DESCRIPT, SUM(DETAIL.QTY);
  16.  FROM CUSTOMER, INVOICES, DETAIL, PARTS;
  17.  WHERE INVOICES.CNO = CUSTOMER.CNO;
  18.    AND DETAIL.INO = INVOICES.INO;
  19.    AND PARTS.PNO = DETAIL.PNO;
  20.  GROUP BY CUSTOMER.COMPANY, PARTS.PNO;
  21.  HAVING SUM(DETAIL.QTY) > 4;
  22.  ORDER BY CUSTOMER.COMPANY;
  23.  INTO CURSOR CHAP6004
  24. BROWSE NOMODIFY PREFERENCE CHAP6004
  25.